/*
 Navicat Premium Data Transfer

 Source Server         : zhiyundata-aliyun-北京
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : rm-2ze83dmwmh18p67jtjo.mysql.rds.aliyuncs.com:3306
 Source Schema         : award2021_chhca

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 10/03/2021 20:39:33
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for large_groups
-- ----------------------------
DROP TABLE IF EXISTS `large_groups`;
CREATE TABLE `large_groups` (
  `id` int(11) NOT NULL,
  `award_id` int(11) DEFAULT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint(3) unsigned DEFAULT NULL,
  `attrs` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of large_groups
-- ----------------------------
BEGIN;
INSERT INTO `large_groups` VALUES (1, 1, '路基路面组', 1, '{\n  \"project\": {\n    \"prof_fields\": [\n      \"路基\",\n      \"路面\"\n    ]\n  },\n  \"reviewer\": {\n    \"prof_fields\": [\n      \"路基\",\n      \"路面\"\n    ]\n  },\n  \"award\": {\n    \"awards\": [\n      {\n        \"order\": 1,\n        \"name\": \"一等奖\",\n        \"min_score\": 89.67,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"downgrade\"\n      },\n      {\n        \"order\": 2,\n        \"name\": \"二等奖\",\n        \"min_score\": 79,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"reject\"\n      }\n    ]\n  },\n  \"meeting\": {\n    \"project_num\": 0,\n    \"update_time\": \"2021-01-30 18:00:00\"\n  },\n  \"awards_configure\": [\n    {\n      \"key\": 1,\n      \"title\": \"一等奖\",\n      \"number\": 0\n    },\n    {\n      \"key\": 0,\n      \"title\": \"二等奖\",\n      \"number\": 0\n    },\n    {\n      \"key\": 3,\n      \"title\": \"三等奖\",\n      \"number\": 0\n    }\n  ]\n}');
INSERT INTO `large_groups` VALUES (2, 1, '桥涵组', 2, '{\n  \"project\": {\n    \"prof_fields\": [\n      \"桥涵\"\n    ]\n  },\n  \"reviewer\": {\n    \"prof_fields\": [\n      \"桥涵\",\n      \"桥梁\"\n    ]\n  },\n  \"award\": {\n    \"awards\": [\n      {\n        \"order\": 1,\n        \"name\": \"一等奖\",\n        \"min_score\": 90,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"downgrade\"\n      },\n      {\n        \"order\": 2,\n        \"name\": \"二等奖\",\n        \"min_score\": 80,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"reject\"\n      }\n    ]\n  },\n  \"meeting\": {\n    \"project_num\": 0,\n    \"update_time\": \"2021-01-30 18:00:00\"\n  },\n  \"awards_configure\": [\n    {\n      \"key\": 1,\n      \"title\": \"一等奖\",\n      \"number\": 0\n    },\n    {\n      \"key\": 0,\n      \"title\": \"二等奖\",\n      \"number\": 0\n    },\n    {\n      \"key\": 3,\n      \"title\": \"三等奖\",\n      \"number\": 0\n    }\n  ]\n}');
INSERT INTO `large_groups` VALUES (3, 1, '隧道及地下工程组', 3, '{\n  \"project\": {\n    \"prof_fields\": [\n      \"隧道及地下工程\"\n    ]\n  },\n  \"reviewer\": {\n    \"prof_fields\": [\n      \"隧道及地下工程\",\n      \"隧道\",\n      \"隧道工程\"\n    ]\n  },\n  \"award\": {\n    \"awards\": [\n      {\n        \"order\": 1,\n        \"name\": \"一等奖\",\n        \"min_score\": 90,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"downgrade\"\n      },\n      {\n        \"order\": 2,\n        \"name\": \"二等奖\",\n        \"min_score\": 80,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"reject\"\n      }\n    ]\n  },\n  \"meeting\": {\n    \"project_num\": 0,\n    \"update_time\": \"2021-01-30 18:00:00\"\n  },\n  \"awards_configure\": [\n    {\n      \"key\": 1,\n      \"title\": \"一等奖\",\n      \"number\": 0\n    },\n    {\n      \"key\": 0,\n      \"title\": \"二等奖\",\n      \"number\": 0\n    },\n    {\n      \"key\": 3,\n      \"title\": \"三等奖\",\n      \"number\": 0\n    }\n  ]\n}');
INSERT INTO `large_groups` VALUES (4, 1, '综合组', 4, '{\n  \"project\": {\n    \"prof_fields\": [\n      \"其他\"\n    ]\n  },\n  \"reviewer\": {\n    \"prof_fields\": []\n  },\n  \"award\": {\n    \"awards\": [\n      {\n        \"order\": 1,\n        \"name\": \"一等奖\",\n        \"min_score\": 90,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"downgrade\"\n      },\n      {\n        \"order\": 2,\n        \"name\": \"二等奖\",\n        \"min_score\": 80,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"reject\"\n      }\n    ]\n  },\n  \"meeting\": {\n    \"project_num\": 0,\n    \"update_time\": \"2021-01-30 18:00:00\"\n  },\n  \"awards_configure\": [\n    {\n      \"key\": 1,\n      \"title\": \"一等奖\",\n      \"number\": 0\n    },\n    {\n      \"key\": 0,\n      \"title\": \"二等奖\",\n      \"number\": 0\n    },\n    {\n      \"key\": 3,\n      \"title\": \"三等奖\",\n      \"number\": 0\n    }\n  ]\n}');
INSERT INTO `large_groups` VALUES (5, 2, '科技人物组', 5, '{\n  \"project\": {\n    \"prof_fields\": []\n  },\n  \"reviewer\": {\n    \"prof_fields\": []\n  },\n  \"award\": {\n    \"awards\": [\n      {\n        \"order\": 1,\n        \"name\": \"科学人物奖\",\n        \"min_score\": 80,\n        \"min_support_rate\": [\n          2,\n          3\n        ],\n        \"on_low_support_rate\": \"reject\"\n      }\n    ]\n  },\n  \"awards_configure\": [\n    {\n      \"key\": 1,\n      \"title\": \"科技人物奖\",\n      \"number\": 0\n    }\n  ]\n}');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
